all groups > sql server odbc > june 2006
Accessing Oracle from within SQL Server
Posted by Paul Anderson at 6/28/2006 12:00:00 AM
Using Oracle's Heterogeneous Services, it's possible to gain access to
SQL Server tables via ODBC.
Is the reverse possible? Does SQL Server have the ability to read/write
from/to an Oracle table using ODBC? Is there anything to install? Or
is this functionality that comes with SQL Server?
... more >>
jet oledb from tsql
Posted by Nick Thompson at 6/23/2006 3:19:01 AM
I wish to create a new access database each week whos name includes the
curent date, then to create 7 tables in the database eg '27 Jul 2006.mdb' one
for each day
I then wish to insert rows into these tables,
currently I use managed adox & ado to do this, is it possible to use tsql to
get
... more >>
PROGRESS import of field freezes SQL Server
Posted by Philippe at 6/16/2006 4:04:02 AM
hi,
I've got a SQL 2005 with an odbc connection to a PROGRESS database. We can
transfer data from the progress to the sql but there is 1 field we can not
transfer. This field, proclaimed by the PROGRESS administration, is a field
wich can contain an empty string or up to 8 characters.
Bu... more >>
Transaction cannot start while in firehose mode!
Posted by Ole Martin at 6/8/2006 2:37:02 AM
Hi!
I get this message when I try to change a record: Transaction cannot start
while in firehose mode!
Anyone now how to solve this problem? I can read/write to my table, but I
cant change records.
Help much appretiated, Thanks
Ole Martin... more >>
Error when importing data from AS/400 - appeared after SP1
Posted by dr at 6/7/2006 12:00:00 AM
I cannot transfer a list of tables from AS/400 to SQL 2005, in SQL Server
Import and Export Wizard.
This is what happends:
In SQL server Import and Export wizard, I choose IBM AS400 OLE DB Provider,
with Properties:
Data Source: (IP adress of my AS/400)
User name, password: (My username/... more >>
MSSQL 2005 Enterprise vs. Standard edition
Posted by Jodie at 6/6/2006 6:14:01 PM
Hi All,
What is the different between MSSQL 2005 Enterprise and Standard edition.
Thanks
Jodie... more >>
When Microsoft release MSSQL 2005
Posted by Jodie at 6/6/2006 9:15:01 AM
Just a question about MSSQL 2005- When MSSQL 2005 released by Microsoft.
Are there a lot of users using this MSSQL 2005?
Thanks,
Jodie... more >>
Linked Server to DBC Data
Posted by REM7600 at 6/5/2006 8:12:35 AM
Hi All,
I'm having trouble setting up a linked server OR using an OpenRowset =
operation from SQL Server against once of the DBC files from one of our =
vendors. =20
I can get connected through a DSN using Microsoft Access without trouble =
but when trying to set up a linked server on the s... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
|