[DB-SIG] Opening a connection for a Microsoft SQL Server Database

[Tom Rabaut]

I'm having trouble getting a connection with my SQL Server Database. My =
webserver and script is sitting on my D drive and my database is on my C =
drive, how should I be referencing the database file? Currently my code =
looks something like this:

	connection =3D odbc.odbc('C:/Program File/..../database')

The debugger is telling me that it cannot find the file. Do I need to =
include the database extension? Am I referencing the C drive =
incorrectly. Thanks Tom