i want to insert a xml file into the sql server using asp.net.can sm1 help me wth d coding part?What server version you use?
In 2005 - there is XML datatype and almost unlimited size of XML.
In 2000 - for character datatype you limited to 8000 characters unless you are going to use text datatype.sql
Hi
I have tried to import Pervasive Database to SQL Server 2005.
I am not getting any option in Data Source for Pervasive So I tried following
I have Provided the following Connection String to SQL server Import and Export Wizard (in .net framework data provider for ODBC)
Connectio String: Dsn=DEMODATA;Driver={Pervasive ODBC Engine Interface}
DSN: DEMODATA
Driver:Pervasive ODBC Engine Interface
but i m getting error that "Can not get supported data types from th database connection."
Can you please look in to it and tell me possible ways by which I can import pervasive Database into SQL server 2005.
and let me know if there is any other tool by which we can see "Pervasive ODBC Engine Interface"
in Data Source
Thanks,
Arun
Unless there is another Pervasive user out there who can help you, I would suggest the following: try building the package in the designer rather than through the wizard. The designer in Business Intelligence Development Studio offers more options than the wizard, which only covers simple scenarios.
Having said that - if the provider does not return data type information, it may yet be a problem.
Donald
|||Did you ever get this resolved?|||I am Currently working in a ETL project that extracts data from Pervasive V8 DB. I wanted to use OLE DB connection but I could not make it work; so I am using ODBC. I installed the ODBC driver in my the development stations and the SSIS server (as a part of the Client tool Pervasive.SQL Data Manager installation); then I defined the Dsn. Whitin SSIS I defined my datasaource as:
Provider: .Net Providers\Odbc Data Provider
Use user or System data SOurce Name: <Choose from dropdown list my dsn>
The conction string of the data source is just simple: Dsn=<MyDsn>
And I was ready to go...
Then I had problems in the server because it is x64 bit machine; but that is a different story.
Rafael Salas
|||I'm on Pervasive 2000i... my issue is that I'm trying to use the demodata dsn and I get the following error:
Cannot get the supported data types from the database connection "Dsn=demodata;Driver={Pervasive ODBC Engine Interface}".
Additional information:
--> Specified cast is not valid. (System.Data)
|||German,
Did you try what Donald Suggested you? All what I did was inside of BIDS and actually I never tried with the wizard since I needed to perform some transformations before writing into the destination table
Rafael Salas
Hi
I had to recover my computer but before I did that I grabbed a new version of my mdf file but I don't know how to actually import it into SQL Server Management Studio Express evertime I try to open the file up it just crashes.
I rather not have to redue that whole database again. I am a noob so step by step instructions are needed.
Thanks
Open SQL Management Studio Express and log in to the server to which you want to attach the database. In the 'Object Explorer' window, right-click on the 'Databases' folder and select 'Attach...' The 'Attach Databases' window will open; inside that window click 'Add...' and then navigate to your .MDF file and click 'OK'. Click 'OK' once more to finish attaching the database and you are done. The database should be available for use.
Thanks but I get an error.
I think I got it working.
|||
aggiekevin:
Open SQL Management Studio Express and log in to the server to which you want to attach the database. In the 'Object Explorer' window, right-click on the 'Databases' folder and select 'Attach...' The 'Attach Databases' window will open; inside that window click 'Add...' and then navigate to your .MDF file and click 'OK'. Click 'OK' once more to finish attaching the database and you are done. The database should be available for use.
This is true. One important note I would like to menion is, it is highly recomended to take a copy of .mdf file bedore attaching it to the new database. Why? Because if this .mdf file was one of the SQL Server 2000 databases and you attached it to one of the SQL Server 2005 databases. There is no way -if you wish in futute- to detach that .mdf file from SQL Server 2005 and attached it again in SQL Server 2000 or eailer version.
Good luck.
|||Thanks
