SQL Server Express ODBC Default DB

Question

SQL Server Express ODBC Default DB

Larry McGahee

SSC Rookie

Points: 25
More actions
September 13, 2006 at 8:14 am

#170347

I have created a SQL Server Express database using MS Visual Studio 2005 and need to create an ODBC connection to this database to allow other non-vb.net applications to connect to it. When going into the ODBC configuration tool, I enter "localhost\sqlexpress" for the server and choos "SQL Native Client" for the driver. When on the section for choosing the default database, the database does not appear.
How can I set up the default database to reference this database file?
I appreciate any help available.
Thanks,
Larry

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

mrivera Ten Centuries Points: 1050 More actions · Answer 1

I tried creating an ODBC conn to one of the databases in my SQL Server Express and it worked just fine. Would the problem be a security issue? I am using the db owner as I create the connection.

Monica

Larry McGahee SSC Rookie Points: 25 More actions · Answer 2

Monica,

I don't think that it is a security issue. I can create the ODBC DSN, but I don't see my DB listed in the default database drop down box. How do I get ODBC to reference this database?

Thanks,

Larry

mrivera Ten Centuries Points: 1050 More actions · Answer 3

Hi Larry,

When I created the connection, I was able to see all my databases in the drop down menu. Is your db online?

Larry McGahee SSC Rookie Points: 25 More actions · Answer 4

Monica,

I found the errror in my ways. I had to download the SQL Manager Express application from Microsoft and use it to create my database. Apparently VS 2005 creates the database but not in a fashon that the ODBC configuration tool can see. After creating the database in SQL Manager Express, the ODBC configuration tool was able to see it.

Thanks again for your help!!

Larry